-- MySQL dump 10.13  Distrib 5.6.12, for Win32 (x86)
--
-- Host: localhost    Database: mz2_shop
-- ------------------------------------------------------
-- Server version	5.6.12-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `address` varchar(255) NOT NULL DEFAULT '天堂',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

LOCK TABLES `address` WRITE;
/*!40000 ALTER TABLE `address` DISABLE KEYS */;
INSERT INTO `address` VALUES (1,19,'dasda',0),(3,5,'江苏',1),(5,5,'北京',1),(6,5,'完全而且',1),(7,5,'123',1),(8,6,'南京',1),(9,8,'北京',1),(10,9,'adsf',1),(11,11,'qwerqwer',1),(12,11,'qwer',1),(13,3,'驱蚊器',1),(14,4,'nishi ',1);
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `addver`
--

DROP TABLE IF EXISTS `addver`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `addver` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` tinyint(4) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT 'av.jpg',
  PRIMARY KEY (`id`),
  UNIQUE KEY `address` (`address`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `addver`
--

LOCK TABLES `addver` WRITE;
/*!40000 ALTER TABLE `addver` DISABLE KEYS */;
INSERT INTO `addver` VALUES (6,1,1,'201607145787567ca76c9.jpg'),(8,2,1,'20160715578849e5797fb.jpg'),(9,3,1,'2016071557884a2611aa0.jpg');
/*!40000 ALTER TABLE `addver` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_user`
--

DROP TABLE IF EXISTS `admin_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `admin_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(32) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `order` tinyint(4) NOT NULL DEFAULT '2',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `addtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin_user`
--

LOCK TABLES `admin_user` WRITE;
/*!40000 ALTER TABLE `admin_user` DISABLE KEYS */;
INSERT INTO `admin_user` VALUES (1,'admin','e10adc3949ba59abbe56e057f20f883e',0,1,1466039539);
/*!40000 ALTER TABLE `admin_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `arguments`
--

DROP TABLE IF EXISTS `arguments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `arguments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `text` text NOT NULL,
  `rtext` text,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `arguments`
--

LOCK TABLES `arguments` WRITE;
/*!40000 ALTER TABLE `arguments` DISABLE KEYS */;
INSERT INTO `arguments` VALUES (6,5,3,'请我',NULL,0),(7,6,5,'nishishui',NULL,1),(8,6,5,'nishia d',NULL,0),(9,6,5,'12ecc',NULL,0);
/*!40000 ALTER TABLE `arguments` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(32) NOT NULL,
  `pid` int(11) NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL DEFAULT '0,',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `addtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'你好',0,'0,',0,1466575829),(5,'as1231',0,'0,',0,1466586849),(6,'sada12',0,'0,',0,1466587124),(9,'123',0,'0,',0,1466591157),(11,'a123132',5,'0,5,',1,1466591392),(13,'3453',0,'0,',1,1466591749),(14,'ghfgh',0,'0,',0,1466591763),(15,'564',0,'0,',1,1466593709),(16,'admin',6,'0,6,',1,1466593779),(17,'231',1,'0,1,',0,1467031330),(20,'131e',0,'0,',1,1467103423),(21,'多发点',1,'0,',1,1468475741),(22,'多发点',1,'0,',1,1468475759),(23,'企鹅完全',18,'0,',1,1468475777),(26,'wqe',17,'0,1,17,',1,1468476981),(27,'2312312',1,'0,1,',1,1468978364),(28,'123aas',17,'0,1,17,',0,1468978398),(29,'1131',15,'0,15,',0,1468978465);
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods`
--

DROP TABLE IF EXISTS `goods`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `cate_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `stok` int(11) NOT NULL DEFAULT '1',
  `is_new` tinyint(4) NOT NULL DEFAULT '1',
  `is_hot` tinyint(4) NOT NULL DEFAULT '1',
  `is_bast` tinyint(4) NOT NULL DEFAULT '1',
  `describe` text,
  `addtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods`
--

LOCK TABLES `goods` WRITE;
/*!40000 ALTER TABLE `goods` DISABLE KEYS */;
INSERT INTO `goods` VALUES (2,'u币',2,1,122.00,13,1,1,1,'帮黄骏国i',1466576333),(4,'御姐',2,1,100000.00,12,1,1,1,'12ewe',1466576815),(5,'a12312312',2,1,12.00,12,1,1,1,'热舞热舞v',1466578030),(6,'阿斯达',8,1,123.00,12,1,1,1,'阿斯顿v啊',1466602154),(7,'1231',12,1,123.00,12,1,1,1,'12对的11 ',1466602314),(30,'大黄牛',1,1,123.00,13141,1,1,1,'2耳朵',1468917094),(31,'美美',1,1,1231.00,120,1,1,1,'3123123',1468939680),(32,'落花生',1,1,21312.00,123122,1,1,1,'231231',1468939701),(36,'让3',14,1,1313.00,3119,1,1,1,'12312',1468940076),(37,'3123',1,1,1231.00,313,1,1,1,'31231',1468940090),(38,'阿黄',1,1,12312.00,23119,1,1,1,'312312',1468940114),(39,'我玩',23,1,123.00,12338,1,1,1,'123123',1468940149),(40,'话',21,1,132.00,13213,1,1,1,'13123',1468940189),(41,'你好啊',6,1,3123.00,131241,1,1,1,'13123',1468940218),(42,'nihao ',1,1,123123.00,123,1,1,1,'1321231',1468978335);
/*!40000 ALTER TABLE `goods` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goods_img`
--

DROP TABLE IF EXISTS `goods_img`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goods_img` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT 'no.jpg',
  `is_face` tinyint(4) NOT NULL DEFAULT '0',
  `goods_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goods_img`
--

LOCK TABLES `goods_img` WRITE;
/*!40000 ALTER TABLE `goods_img` DISABLE KEYS */;
INSERT INTO `goods_img` VALUES (2,'20160622576a2dcd991c0292264d5b2a58d2c4828fa183a1cce23.jpg',0,2),(4,'20160622576a2e41d8fd2ebc004ec5144030d8c365456db040dc1.jpg',1,0),(5,'20160622576a2e494a452167cacf79c851c2fb628a3706bcbc991.jpg',0,0),(6,'20160622576a2faf5753a767c23430487b6c64d45b83d5d32e9a1.jpg',1,4),(7,'20160622576a346ec50379fded3b27e1ec2a48d42e084506daced.jpg',1,5),(8,'20160622576a348138c8d50de016246f61bd386c05e033920d998.jpg',0,2),(9,'20160622576a3530bb9ed5f64ff393e8a950fe394ea5018f91823.jpg',1,2),(10,'20160622576a92aa9b51a0b52b5d41f25672816779518fa40b18c.jpg',1,6),(11,'20160622576a934a2049bcaa24a38ceed6b3d3063f5bada1d9a3b.jpg',1,7),(34,'20160719578de56678e15.jpg',1,30),(35,'20160719578e3da06ed50.jpg',1,31),(36,'20160719578e3db593042.jpg',1,32),(40,'20160719578e3f2c7da3d.jpg',1,36),(41,'20160719578e3f39f3810.jpg',1,37),(42,'20160719578e3f523c013.jpg',1,38),(43,'20160719578e3f758484e.jpg',1,39),(44,'20160719578e3f9cc67f4.jpg',1,40),(45,'20160719578e3fb9d87b3.jpg',1,41),(46,'20160720578ed49f03166.jpg',1,42);
/*!40000 ALTER TABLE `goods_img` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_info`
--

DROP TABLE IF EXISTS `order_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` int(11) NOT NULL,
  `goods_id` int(11) NOT NULL,
  `num` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_info`
--

LOCK TABLES `order_info` WRITE;
/*!40000 ALTER TABLE `order_info` DISABLE KEYS */;
INSERT INTO `order_info` VALUES (1,1,30,1),(2,2,30,2),(4,4,38,4),(5,5,36,4),(6,6,30,1),(7,6,39,3);
/*!40000 ALTER TABLE `order_info` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_list`
--

DROP TABLE IF EXISTS `order_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordernumber` varchar(255) NOT NULL,
  `is_fu` tinyint(4) NOT NULL DEFAULT '0',
  `is_show` tinyint(4) NOT NULL DEFAULT '0',
  `add_id` int(11) NOT NULL,
  `uid` int(11) NOT NULL,
  `addtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_list`
--

LOCK TABLES `order_list` WRITE;
/*!40000 ALTER TABLE `order_list` DISABLE KEYS */;
INSERT INTO `order_list` VALUES (1,'Mz220160719578e13ed29d71385',0,0,10,9,1468929005),(2,'Mz220160719578e1407956312012',0,0,10,9,1468929031),(4,'Mz220160719578e4217c942d3139',1,2,13,3,1468940823),(5,'Mz220160719578e427cb04d82819',1,2,13,3,1468940924),(6,'Mz220160720578ed3d2942eb1084',1,2,3,5,1468978130);
/*!40000 ALTER TABLE `order_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(32) NOT NULL,
  `pwd` varchar(255) NOT NULL,
  `sex` tinyint(4) NOT NULL DEFAULT '0',
  `regtime` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'1','d41d8cd98f00b204e9800998ecf8427e',0,1468932593,0),(2,'2131','d41d8cd98f00b204e9800998ecf8427e',0,1468932603,0),(3,'admin','202cb962ac59075b964b07152d234b70',0,1468934646,0),(4,'123aas','202cb962ac59075b964b07152d234b70',0,1468976492,1),(5,'admin123','202cb962ac59075b964b07152d234b70',0,1468978073,0);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_info`
--

DROP TABLE IF EXISTS `user_info`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `age` int(11) NOT NULL DEFAULT '0',
  `tel` char(32) NOT NULL DEFAULT '110',
  `birthday` int(11) NOT NULL DEFAULT '0',
  `email` varchar(255) NOT NULL DEFAULT 'lamp@163.com',
  `qq` int(11) NOT NULL DEFAULT '110',
  `face` varchar(255) NOT NULL DEFAULT 'no.jpg',
  `name` varchar(255) NOT NULL DEFAULT 'xx',
  `logintime` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_info`
--

LOCK TABLES `user_info` WRITE;
/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
INSERT INTO `user_info` VALUES (1,1,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(2,2,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(3,3,0,'110',0,'lamp@163.com',110,'20160719578e32d231413.jpg','xx',0),(4,4,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(5,5,13,'110',0,'lamp@163.com',12312312,'20160720578ef4f852987.jpg','xx',0),(6,6,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(7,7,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(8,8,0,'110',0,'lamp@163.com',110,'20160718578cfc0bc8975.jpg','xx',0),(9,9,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(10,11,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(11,12,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(12,14,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(13,16,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(14,17,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(15,18,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(16,1,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(17,2,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(18,3,0,'110',0,'lamp@163.com',110,'20160719578e32d231413.jpg','xx',0),(19,4,0,'110',0,'lamp@163.com',110,'no.jpg','xx',0),(20,5,0,'110',0,'lamp@163.com',110,'20160720578ef4f852987.jpg','xx',0);
/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-07-20 19:10:02
